set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--CREATEd:02/08/2010
--Author: nnamthach@gmail.com
Create procedure [dbo].[procProducts_getTopNew]
AS
BEGIN
SELECT     TOP (5) Code, ID, NameVN, Image, NewPrice, BEN_H, BEN_S, BEN_C, BEN_R, BEN_F
FROM         Products
GROUP BY Code, ID, NameVN, Image, NewPrice, BEN_H, BEN_S, BEN_C, BEN_R, BEN_F
ORDER BY ID DESC
END

